star_border star_border star_border star_border star_border
We will cover the following most common Excel formulas for intermediate users: Vlookup If Statements SumIF AverageIF CountIF TRIM Concatenate Left, Right, Mid Data Validation Removing Duplicates Conditional Formatting Data Filters We also cover dynamic formulas versus static formulas, a few shortcuts here and there and the relative versus absolute references (otherwise known as locking cells). This course is designed for Intermediate users as we do not cover basic formulas like addition, subtraction, etc...
    starstarstarstarstar_half
    O curso vai lhe ensinar a pesquisar dados usando uma das funções mais importantes do Excel. Você aprenderá a fazer pesquisa exatas, aproximadas, inversas e dinâmicas. É uma verdadeira imersão na função PROCV. Retorne todos os resultados com a PROCV e aprenda a criar um relatório com filtro de datas. Após dominar a PROCV, você conhecerá a poderosa combinação de Funções ÍNDICE e CORRESP. Aprenderá também a criar imagens vinculadas, listas exclusivas e classificar listas automaticamente.
      starstarstarstarstar_border
      This course is all about excel functions, if you are looking for automating your job and make it easier this is the right course for you, so excel functions are so important for 2 main reasons, the first one is time saving and the second one is eliminating human errors. In this course you will learn over 40 most important excel functions, for each function i will explain it in details and show you its syntax then will show you how to do it in excel sheets step by step.
        star_border star_border star_border star_border star_border
        In diesem Kurs lernst Du, wie Du eine Tabellenkalkulation (z.B. MS Excel, Google Sheets oder LibreOffice Calc) sinnvoll und professionell für praktische Aufgaben aller Art einsetzen kannst. Mit Hilfe von Tabellenkalkulationen kannst Du Analysen und Auswertungen durchführen, Kosten kalkulieren, Planungsaufgaben erledigen und Daten verwalten. Anhand von zahlreichen praktischen Beispielen und Übungen kannst Du in diesem Kurs den Umgang mit Formeln, Funktionen, Diagrammen und bedingten Formatierungen auf hohem Niveau erlernen.
          starstarstarstarstar_half
          Excel Formulas can seem daunting and even scary at first. In this course Excel formulas are made easy as you learn all the essential skills to writing formulas. Master Excel Formulas Easily with this Comprehensive Course Understand Excel formulas inside out. Learn over 60 different Excel functions. Write complex formulas with ease. Recognise formula errors and fix common problems. Hear What Some of our Students have Been Saying "Great instructor and excellent way of explaining." "Brilliant course! Finally a course that leaves you understanding everything without needing to review a dozen times. I have reviewed and learned much more from this easy to follow course due to the step by step tutorials and its clear, engaging delivery by an excellent and knowledgeable instructor. It has helped me understand more formulas in excel that can help me with my business. Many thanks to all involved and keep up the great work." "straight to the point, clear explanation and demo, use common sense language to interpret the formula, and simple and easy illustrative example." Learn Everything You Need to Write Formulas with Ease . Formulas are what drive Excel. They are the muscles allowing users to manipulate, lookup, aggregate and test data with ease. Learning how to write formulas is an important skill for any Excel user looking to develop their talents. Content and Overview This course was designed for anybody who needs to be able to confidently work with formulas in Excel. It is suitable both for complete beginners who want to start from the basics, and for those that have some experience but want to take things further. The course is broken into different sections. It starts with building an understanding of the different elements of a formula, what the various symbols mean, some basic functions and different techniques for referencing cells. Each section then focuses on a specific function category such as date or lookup functions. It starts to take things further by tackling mini projects and looking at more advanced formulas. In over 80 lectures this course will teach you all the necessary skills to write advanced formulas with ease, and make those formula demons a thing of the past. Working files are provided so that you can follow along and practice. You can also get assistance from myself with any queries you may have.
            starstarstarstarstar_half
            Learn to calculate how much money you can save by making additional payments into your home loan / mortgage or other loan. In this course we'll learn how to use the Financial Loan formulas in Excel to calculate how much money you can save when making additional payments into your loan.  We'll also learn to calculate the exact period at which you can pay your loan off.  This will really assist you to set achievable goals regarding your outstanding mortgage bond. This course will take you through a step-by-step guide to create a spreadsheet which details the payment for each period of a loan over the lifetime of the loan.  In the example we look at a mortgage bond of 1,500,000 which is paid monthly over 20 years. The course is created using Excel 2016 and although prior versions of Excel have all the same functionality, the screen may look different so if you are not comfortable using Excel you could get confused.  You really should have some basic knowledge of Excel already and you should be able to use formulas and understand how to link cells into formulas. The topics we cover in the course are: The Excel PMT function to calculate the monthly payment The Excel IPMT function to calculate the interest portion of each months payment The Excel PPMT function to calculate the principal (capital) portion of each months payment The Excel IF function for logical conditions It is very encouraging to calculate how much you can save on your bond with even small additional amounts! You can easily find templates or similar calculations but this course will truly help you understand how a loan works.
              starstarstarstarstar_half
              In this course you will learn how to use a number of formulas that will help you get your work done with less effort, as well as how to leverage the benefits of Excel tables.  You will also learn about using conditional formatting. This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5. Recent reviews: "This training was very helpful in upgrading knowledge in Excel with the help of practical exercises. I would definitely recommend this course." "Excellent, efficient and informative course. The exercises after each set of videos was particularly useful." "I found the course very informative. I am pretty good with excel but I learned quite a few tips and tricks that I can implement." In this course you will learn how to use a number of formulas that will help you get your work done with less effort, as well as how to leverage the benefits of Excel tables.  You will also learn about using conditional formatting. This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5. **** Life time access to course materials and practice activities. **** Welcome to this course on Tables, Conditional Formatting and Excel formulas.  This course is for all Excel users who want to take their Excel skills and capabilities to the next level. This course will increase your productivity as you use tables, conditional formatting and formulas with ease in your Excel spreadsheets.  The course is presented in an easy to follow step by step approach.  The course also includes practical activities for you to practice the skills that you have been learnt on the course. The course will provide you with a comprehensive understanding of the following: Tables How to create and format Tables How to easily filter data in text, numeric and date fields Easily Sum, Average, Count and use Max and Min in your tables Use Slicers to easily filter Table data Conditional Formatting How to apply conditional formatting rules How to easily highlight the Top 10 Learn to use Data Bars and Color Scales Learn to apply icons Formulas Learn SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF and COUNTIFS Learn a range of Date formula such as Year, Month, WeekDay, NetWorkDays amd WorkDay Learn Text formulas such as LEFT, MID, RIGHT and TRIM Learn to use the IF formula to create powerful 'IF Then' logic Learn the HLOOKUP and VLOOKUP This course is presented in Excel 2013. A minimum of Excel 2007 is required to be able to work with the Tables, Conditional Formatting and some of the formula functions.
                star_border star_border star_border star_border star_border
                WHAT’S YOUR STORY? Are you a business professional needing to up-skill? Are you struggling to get a pay-rise and/or promotion? Are you a recent graduate with an empty looking resume and no job experience? Have you recently been laid off, fired or had a contract end? If you answered 'yes' to any of the above then having “Expert Microsoft Office Skills” will get you closer to your goal of either landing your first job, a new job or progressing further in your current role. Here's why. The job market has never been more volatile. Statistically, people are changing jobs more often now than they ever have before and that also means people are also losing jobs to newcomers who are far more skilled. So if you’re not up-skilling, you’re falling behind. It’s scary I know. I’ve experienced this myself. A study released by Microsoft and the IDC showed that among 14.6 million job postings, proficiency in Microsoft Office was ranked 2nd as the most desired skills by employers leading up to 2020. Microsoft Office proficiency ranked higher than Project Management skills, Sales Experience, Time Management, Analytical Skills, Interpersonal Skills and Work Ethics. This is because we live in the digital age, meaning employers are looking for proficient data handlers who process data faster, are more data-organised and can communicate effectively via digital channels. These are skills everyone should have no matter the discipline because they are transferable skills. It makes you more adaptable and more valuable in the long-term. This brings us back to Microsoft Office. It is the oldest, most well-known, most affordable and most trusted data management tool available and hence everyone uses it. So to be noticed and taken seriously in your job or job application, proficiency in these programs is compulsory. ONLINE TRAINING AND THE MOST COMMON PROBLEMS One of the most common problems with online learning content is that there is so much of it now and it’s difficult to know where to start or who to turn to. Many go the YouTube route and piece together videos from hundreds of tutorials from hundreds of tutors hoping to become an expert at the end of it all. This simply won’t happen and will just waste your time. Many take the route you’re about to take, they decide to enroll in an online training course. Many charge hundreds, sometimes thousands of dollars for their courses which is simply unaffordable for university students, recent graduates, the unemployed or those looking for a career change. That is the reason why I have decided to keep this course as low as possible even though I’m offering substantially more content than most of my competitors here on Udemy. COURSE DELIVERY STYLE I have been using Microsoft Office for over 20 years. I know the in’s and out’s and the simplest ways of doing things. My delivery philosophy is simple, if I can’t get a 6 year old to follow along and understand, than I’m not teaching correctly. I hate complicated language and so do you. Nobody likes trainers who focus on impressing rather than teaching and giving value to students. That is also why my lecture videos are as short as can be and divided into small sections for easy consumption. So you won’t get unnecessary chit chat or nonsense. I also assume that all my students are near-sighted and as such, I use a special software tool that allows me to draw on the screen to show exactly what I’m about to press as well as zoom in on small area’s so you don’t miss a thing. WHAT YOU’LL LEARN IN THIS COURSE The proper use and understanding of formula's in Microsoft Excel is essential in mastering the full program. It is a foundation skill that should not be ignored! I'll teach you from the ground up how to construct and perform manual calculations, nested formula's, logic based functions, cell linkages, autosum functions and text/number concatenation. Along with these functions I'll also cover additional techniques such as decimal place setting and formula expansion. ABOUT ME Member of the Udemy Council Co-Founded Paperclip Learning which teaches Microsoft Office Over 60,000 students Over 130,000 enrollments Over 5,000 Positive Reviews Over 20 courses on Udemy Teaching is my passion and my creative outlet. I have been using the Microsoft Office package since I was a child and have been using it consistently throughout my life. My teaching experiences span from teaching primary school students, high school students, university graduates and business professionals. Professionally, I am trained in Aerospace Engineering, Database Design and Business Analytics. TESTIMONIALS Yu Hui Jun Yu - The courses are simply amazing and I can learn them rapidly. The hints presented were also very useful. I like the 'mini-lesson' format. Fast and efficient. The instructor's direction is very detailed and easy to understand. I can immediately start using this program. Thanks! Narayanan Krishnamoorthy - Perfect and to the point...the instructor doesn’t waste time and gets to the point quickly!! Lala Darchinova - I've been looking for this kind of course for ages! And finally I find it. Short, comprehensive and absolutely interesting! Thank you for the work you are doing. Spencer Berkman - Extremely knowledgeable and clear on instructions. E Frank - Simple to learn techniques and instructor made it all really easy. Thank you! Parth Gandhi - I learned techniques in a very short time...no need to google and waste time finding the perfect approach
                  star_border star_border star_border star_border star_border
                  Master Excel Formulas, Tips & Tricks. Learn to use Excel's Amazingly Powerful Formulas and the Tips and Tricks I've picked up over the past 20 years using Excel. It doesn't take that much effort to go from someone barely proficient in utilizing Excel to become the Superstar at your organization. Being the Excel Guru has afforded me a lot of opportunities where I may not otherwise have the chance to participate. We'll look at formulas, tips & tricks that I use almost every day while working. I don't want this training to end there. I'd like as much participation on your part as possible, letting me know exactly what problems you are having a tough time solving. This way I can learn what issues you are having and cater the training to meet YOUR needs! So what you are waiting for? Sign up right now and let's get started. See you inside!
                    starstarstarstarstar_border
                    "Dieser Kurs übertrifft meine Erwartungen. Es ist äußert umfangreich, sehr anschaulich erklärt und bietet Möglichkeiten zum nachmachen." (★★★★★, Marcel Blank) "Der Kurs ist sehr umfangreich und locker vorgetragen! Danke!" (★★★★★, Marie Eichmann) Der Excel-Kurs für Fortgeschrittene & Profis 2021! VBA & Tricks! Themenübersicht Diese Funktionen musst Du kennen! 1. Automatisches Speichern in OneDrive 2. Excel Arbeitsblättern drucken 3. Der Blattschutz in Excel 4. Überwachung von Formeln in Excel 5. Entfernen von Duplikaten in Excel 6. Der Namensmanager in Excel 7. Weg der Daten durch die Formeln nachvollziehen 8. Dropdown-Listen in Excel 9. Dynamische Unterkategorien beim Dropdown 10. Ungültige Auswahlen im Dropdown hervorheben 11. Bildwechsel per Dropdown in Excel 12. Fixierung & Gruppierung von Zeilen & Spalten 13. Die Zielwertsuche in Excel 14. Der Szenario-Manager in Excel 15. Sparkline-Charts in Excel 16. Kommentare, Chat und Notizen in Excel 17. Bonus: Besondere Tastenkombinationen in Excel 18. Bonus: OneNote und Excel Analytische Profi-Funktionen in Excel 1. Datenbankformeln Grundlagen 2. Die wichtigsten Verweis-Funktionen in Excel 3. Der INDEXVERWEIS killt den S-VERWEIS 4. Dynamische Navigation in Tabellen Hyperlink 5. Funktion ERSTERWERT als Alternative 6. BEREICH VERSCHIEBEN in Excel 7. Excel-Listen per Formel transponieren 8. UND-/ODER-Formeln in Excel 9. Die wichtigsten Text-Funktionen in Excel 10. Die wichtigsten Aggregatfunktionen 11. Ungleiche Einträge in Excel-Liste aufspüren Neue Excel-Funktionen für Profis 2020 1. Fuzzy-LookUp in Excel 2. Der X-VERWEIS killt den S-VERWEIS! 3. Der X-Vergleich in Excel 4. MINWENNS kleinster Wert unter Bedingungen 5. XODER-Funktion in Excel Nur Profis sind diese Funktionen bekannt 1. Datentypen Aktien und Geografie in Excel 2. Alle Unicode-Zahlen eines Textes anzeigen 3. Durchgestrichene Zellen einfärben 4. Tabellennamen per Formel auflisten 5. Schrittaufzeichnung zur Dokumentation in Excel 6. Excel-Standarddatei Mappe personalisieren 7. Kopieren und Verschieben von Datensätzen zwischen Excel-Tabellen 8. Rückwärtssuche in Excel-Listen 9. Inputfelder in Excel hervorheben 10. Werte in Formeln umwandeln 11. Zeilenhöhe und Spaltenbreite millimetergenau justieren 12. Bedingte Formatierung ein- und ausschalten 13. Erweiterte Filterungsoption in Excel 14. Filter jeder zehnten Zeile in Excel 15. Die intelligente Office-Zwischenablage Mathematische Formeln 1. Finanzmathematik in Excel 2. Gleichungssysteme lösen in Excel 3. Deskriptive Statistik in Excel 4. Umrechnung von Bogenmaß und Gradmaß in Excel 5. Flächen und Volumen umrechnen VBA Programmierung in Excel 1. Was Programme alles können 2. Was Du mit Excel VBA Makros alles machen kannst 3. Ein wichtiger Unterschied zwischen Excel-Formeln und VBA Makros 4. Makro-Aufzeichnungen in Excel 5. VBA Programmiertools in Excel aktivieren 6. Den Programm-Code anschauen und ändern 7. Wie Du das Makro mit einem Button verknüpfst 8. Module und "Subs" wirst Du am häufigsten brauchen 9. Warum Du den "Debugger" unbedingt brauchst 10. Den User nach einer Eingabe fragen und diese weiter verwenden 11. Verschiedene Formen der Parameter-Übergabe 12. Eine Zelle markieren und den Wert ändern 13. Die Farben einer Zelle verändern (bessere Methode & meine flammende Rede dazu) 14. Ganze Bereiche in die fremde Datei kopieren 15. Deine erste IF-Abfrage 16. Schleifen sind der wichtigste Unterschied zwischen Excel-Formeln und VBA Makros 17. Das erste Beispiel (sogenannte "For-Schleife") erklärt 18. Dropdown mit Referenz auf Alternativliste Bonus: Pivot-Tabellen & Power-Pivot 1. Pivot-Tabellen in Excel 2. Pivot-Datenschnitte in Excel 3. Einführung in Microsoft Power-Pivot 4. Dein erstes Power-Pivot-Projekt 5. Dein zweites Power-Pivot-Projekt Bonus: Einführung in Power-BI 1. Was ist Power-BI? 2. Dein erstes Power-BI-Projekt 3. Dein zweites Power-BI-Projekt -------------------------------------------- Im Kurs zum Download erhältlich Zusammenfassung der Themenkomplexe (PDF) Skript aller inhaltlichen Themen (PowerPoint) Berechnungen der Übungen (Excel) Lösungen der Berechnungen (Excel) Bonus: Übersicht aller Shortcuts in Excel (PDF) Bonus: Übersicht zum Thema Pivot-Tabellen (PDF)